=(B17-$I$5)*$F$7-$F$6 =(C17-$I$5)*$F$7-$F$6 =(Q17) =($F$8)+((D17-$I$5)*$F$7)-$F$6 =(S17) "Trailing Stop Loss: Should initially be the same as the ""Initial Stop" "=(IF(C17<$F$10,1,0))" "=(IF(B17>$F$11,1,0))" "=(IF(OR(O17=1,P17=1),""Out"",""In""))" "=(IF(H17<$F$5,""Yes"",""No""))"
=(B18-$I$5)*$F$7-$F$6 =(C18-$I$5)*$F$7-$F$6 =(Q18) =($F$8)+((D18-$I$5)*$F$7)-$F$6 =(S18) " Loss"" and then adjust as the price moves in" "=(IF(C18<$F$10,1,0))" "=(IF(B18>$F$11,1,0))" "=(IF(OR(O18=1,P18=1),""Out"",""In""))" "=(IF(H18<$F$5,""Yes"",""No""))"
=(B19-$I$5)*$F$7-$F$6 =(C19-$I$5)*$F$7-$F$6 =(Q19) =($F$8)+((D19-$I$5)*$F$7)-$F$6 =(S19) price moves in your favor and according to your "=(IF(C19<$F$10,1,0))" "=(IF(B19>$F$11,1,0))" "=(IF(OR(O19=1,P19=1),""Out"",""In""))" "=(IF(H19<$F$5,""Yes"",""No""))"
=(B21-$I$5)*$F$7-$F$6 =(C21-$I$5)*$F$7-$F$6 =(Q21) =($F$8)+((D21-$I$5)*$F$7)-$F$6 =(S21) Target Stop: Use this if you want to liquidate at a specific profit. "=(IF(C21<$F$10,1,0))" "=(IF(B21>$F$11,1,0))" "=(IF(OR(O21=1,P21=1),""Out"",""In""))" "=(IF(H21<$F$5,""Yes"",""No""))"
=(B22-$I$5)*$F$7-$F$6 =(C22-$I$5)*$F$7-$F$6 =(Q22) =($F$8)+((D22-$I$5)*$F$7)-$F$6 =(S22) "Date Bought: Enter nothing, this is referenced to the date you open" "=(IF(C22<$F$10,1,0))" "=(IF(B22>$F$11,1,0))" "=(IF(OR(O22=1,P22=1),""Out"",""In""))" "=(IF(H22<$F$5,""Yes"",""No""))"
=(B24-$I$5)*$F$7-$F$6 =(C24-$I$5)*$F$7-$F$6 =(Q24) =($F$8)+((D24-$I$5)*$F$7)-$F$6 =(S24) Price Bought: Enter the price at which the order was actually executed. "=(IF(C24<$F$10,1,0))" "=(IF(B24>$F$11,1,0))" "=(IF(OR(O24=1,P24=1),""Out"",""In""))" "=(IF(H24<$F$5,""Yes"",""No""))"
=(B25-$I$5)*$F$7-$F$6 =(C25-$I$5)*$F$7-$F$6 =(Q25) =($F$8)+((D25-$I$5)*$F$7)-$F$6 =(S25) Date Liquidated: Enter the date you liquidated the contract. "=(IF(C25<$F$10,1,0))" "=(IF(B25>$F$11,1,0))" "=(IF(OR(O25=1,P25=1),""Out"",""In""))" "=(IF(H25<$F$5,""Yes"",""No""))"
=(B26-$I$5)*$F$7-$F$6 =(C26-$I$5)*$F$7-$F$6 =(Q26) =($F$8)+((D26-$I$5)*$F$7)-$F$6 =(S26) Price Liquidated: Enter the price at which the contract was actually "=(IF(C26<$F$10,1,0))" "=(IF(B26>$F$11,1,0))" "=(IF(OR(O26=1,P26=1),""Out"",""In""))" "=(IF(H26<$F$5,""Yes"",""No""))"
=(B28-$I$5)*$F$7-$F$6 =(C28-$I$5)*$F$7-$F$6 =(Q28) =($F$8)+((D28-$I$5)*$F$7)-$F$6 =(S28) P/L: Enter nothing. The profit/loss is calculated and includes the "=(IF(C28<$F$10,1,0))" "=(IF(B28>$F$11,1,0))" "=(IF(OR(O28=1,P28=1),""Out"",""In""))" "=(IF(H28<$F$5,""Yes"",""No""))"
=(B30-$I$5)*$F$7-$F$6 =(C30-$I$5)*$F$7-$F$6 =(Q30) =($F$8)+((D30-$I$5)*$F$7)-$F$6 =(S30) "Price Data: Paste or enter the Date, High, Low and Close for each" "=(IF(C30<$F$10,1,0))" "=(IF(B30>$F$11,1,0))" "=(IF(OR(O30=1,P30=1),""Out"",""In""))" "=(IF(H30<$F$5,""Yes"",""No""))"
=(B31-$I$5)*$F$7-$F$6 =(C31-$I$5)*$F$7-$F$6 =(Q31) =($F$8)+((D31-$I$5)*$F$7)-$F$6 =(S31) trading session that the position is open. "=(IF(C31<$F$10,1,0))" "=(IF(B31>$F$11,1,0))" "=(IF(OR(O31=1,P31=1),""Out"",""In""))" "=(IF(H31<$F$5,""Yes"",""No""))"
=(B32-$I$5)*$F$7-$F$6 =(C32-$I$5)*$F$7-$F$6 =(Q32) =($F$8)+((D32-$I$5)*$F$7)-$F$6 =(S32) Profit High: Enter nothing. Calculated by subtracting the price at "=(IF(C32<$F$10,1,0))" "=(IF(B32>$F$11,1,0))" "=(IF(OR(O32=1,P32=1),""Out"",""In""))" "=(IF(H32<$F$5,""Yes"",""No""))"
=(B33-$I$5)*$F$7-$F$6 =(C33-$I$5)*$F$7-$F$6 =(Q33) =($F$8)+((D33-$I$5)*$F$7)-$F$6 =(S33) which you bought the contract from the trading session "=(IF(C33<$F$10,1,0))" "=(IF(B33>$F$11,1,0))" "=(IF(OR(O33=1,P33=1),""Out"",""In""))" "=(IF(H33<$F$5,""Yes"",""No""))"
=(B34-$I$5)*$F$7-$F$6 =(C34-$I$5)*$F$7-$F$6 =(Q34) =($F$8)+((D34-$I$5)*$F$7)-$F$6 =(S34) " high, multiplying by the point value and then subtracting" "=(IF(C34<$F$10,1,0))" "=(IF(B34>$F$11,1,0))" "=(IF(OR(O34=1,P34=1),""Out"",""In""))" "=(IF(H34<$F$5,""Yes"",""No""))"
=(B36-$I$5)*$F$7-$F$6 =(C36-$I$5)*$F$7-$F$6 =(Q36) =($F$8)+((D36-$I$5)*$F$7)-$F$6 =(S36) Profit Low: Enter nothing. Calculated by subtracting the price at "=(IF(C36<$F$10,1,0))" "=(IF(B36>$F$11,1,0))" "=(IF(OR(O36=1,P36=1),""Out"",""In""))" "=(IF(H36<$F$5,""Yes"",""No""))"
=(B37-$I$5)*$F$7-$F$6 =(C37-$I$5)*$F$7-$F$6 =(Q37) =($F$8)+((D37-$I$5)*$F$7)-$F$6 =(S37) which you bought the contract from the trading session "=(IF(C37<$F$10,1,0))" "=(IF(B37>$F$11,1,0))" "=(IF(OR(O37=1,P37=1),""Out"",""In""))" "=(IF(H37<$F$5,""Yes"",""No""))"
=(B38-$I$5)*$F$7-$F$6 =(C38-$I$5)*$F$7-$F$6 =(Q38) =($F$8)+((D38-$I$5)*$F$7)-$F$6 =(S38) " low, multipying by the point